SELECT d.${entityMapper.tableName}_CODE  ,d.NAME FROM ${entityMapper.tableName} d
<${r"#"}if cardone.StringUtils.isNotBlank(term)>
WHERE LOCATE(:term, d.`NAME`) OR LOCATE(:term, d.`${entityMapper.tableName}_CODE`)
</${r"#"}if>
ORDER BY d.ORDER_, d.${entityMapper.tableName}_CODE
LIMIT 20